
-- ----------------------------
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [148.135.51.31:13306/orangeforms_db]
-- ----------------------------

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES(1873979071365386241,NULL,'系统管理',0,NULL,NULL,NULL,NULL,NULL,1,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774848,1873979071365386241,'用户管理',1,'formSysUser',NULL,NULL,NULL,NULL,100,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715617,1873979071373774848,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysUser:fragmentSysUser","permCodeList":["sysUser.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715618,1873979071373774848,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysUser:fragmentSysUser:add","permCodeList":["sysUser.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715619,1873979071373774848,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysUser:fragmentSysUser:update","permCodeList":["sysUser.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715620,1873979071373774848,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysUser:fragmentSysUser:delete","permCodeList":["sysUser.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715621,1873979071373774848,'重置密码',3,NULL,NULL,NULL,NULL,NULL,5,NULL,'{"menuCode":"formSysUser:fragmentSysUser:resetPassword","permCodeList":["sysUser.resetPassword"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774849,1873979071365386241,'部门管理',1,'formSysDept',NULL,NULL,NULL,NULL,105,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715623,1873979071373774849,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysDept:fragmentSysDept","permCodeList":["sysDept.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715624,1873979071373774849,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysDept:fragmentSysDept:add","permCodeList":["sysDept.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715625,1873979071373774849,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysDept:fragmentSysDept:update","permCodeList":["sysDept.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715626,1873979071373774849,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysDept:fragmentSysDept:delete","permCodeList":["sysDept.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715627,1873979071373774849,'设置岗位',3,NULL,NULL,NULL,NULL,NULL,5,NULL,'{"menuCode":"formSysDept:fragmentSysDept:editPost","permCodeList":["sysDept.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715628,1873979071373774849,'查看岗位',3,NULL,NULL,NULL,NULL,NULL,6,NULL,'{"menuCode":"formSysDept:fragmentSysDept:viewPost","permCodeList":["sysDept.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774850,1873979071365386241,'角色管理',1,'formSysRole',NULL,NULL,NULL,NULL,110,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715630,1873979071373774850,'角色管理',2,NULL,NULL,NULL,NULL,NULL,1,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715631,1873979071373774850,'用户授权',2,NULL,NULL,NULL,NULL,NULL,2,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715632,1873979271412715630,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysRole:fragmentSysRole","permCodeList":["sysRole.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715633,1873979271412715630,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysRole:fragmentSysRole:add","permCodeList":["sysRole.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715634,1873979271412715630,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysRole:fragmentSysRole:update","permCodeList":["sysRole.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715635,1873979271412715630,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysRole:fragmentSysRole:delete","permCodeList":["sysRole.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715636,1873979271412715631,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysRole:fragmentSysRoleUser","permCodeList":["sysRole.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715637,1873979271412715631,'授权用户',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysRole:fragmentSysRoleUser:addUserRole","permCodeList":["sysRole.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715638,1873979271412715631,'移除用户',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysRole:fragmentSysRoleUser:deleteUserRole","permCodeList":["sysRole.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774851,1873979071365386241,'数据权限管理',1,'formSysDataPerm',NULL,NULL,NULL,NULL,115,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715640,1873979071373774851,'数据权限管理',2,NULL,NULL,NULL,NULL,NULL,1,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715641,1873979071373774851,'用户授权',2,NULL,NULL,NULL,NULL,NULL,2,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715642,1873979271412715640,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPerm","permCodeList":["sysDataPerm.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715643,1873979271412715640,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPerm:add","permCodeList":["sysDataPerm.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715644,1873979271412715640,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPerm:update","permCodeList":["sysDataPerm.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715645,1873979271412715640,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPerm:delete","permCodeList":["sysDataPerm.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715646,1873979271412715641,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPermUser","permCodeList":["sysDataPerm.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715647,1873979271412715641,'授权用户',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPermUser:addDataPermUser","permCodeList":["sysDataPerm.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715648,1873979271412715641,'移除用户',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysDataPerm:fragmentSysDataPermUser:deleteDataPermUser","permCodeList":["sysDataPerm.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774852,1873979071365386241,'岗位管理',1,'formSysPost',NULL,NULL,NULL,NULL,106,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715650,1873979071373774852,'岗位管理',2,NULL,NULL,NULL,NULL,NULL,1,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715651,1873979271412715650,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysPost:fragmentSysPost","permCodeList":["sysPost.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715652,1873979271412715650,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysPost:fragmentSysPost:add","permCodeList":["sysPost.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715653,1873979271412715650,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysPost:fragmentSysPost:update","permCodeList":["sysPost.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715654,1873979271412715650,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysPost:fragmentSysPost:delete","permCodeList":["sysPost.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774853,1873979071365386241,'菜单管理',1,'formSysMenu',NULL,NULL,NULL,NULL,120,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715656,1873979071373774853,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysMenu:fragmentSysMenu","permCodeList":["sysMenu.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715657,1873979071373774853,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysMenu:fragmentSysMenu:add","permCodeList":["sysMenu.add"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715658,1873979071373774853,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysMenu:fragmentSysMenu:update","permCodeList":["sysMenu.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715659,1873979071373774853,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysMenu:fragmentSysMenu:delete","permCodeList":["sysMenu.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774856,1873979071365386241,'字典管理',1,'formSysDict',NULL,NULL,NULL,NULL,135,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715663,1873979071373774856,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysDict:fragmentSysDict","permCodeList":["globalDict.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715664,1873979071373774856,'新增',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysDict:fragmentSysDict:add","permCodeList":["globalDict.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715665,1873979071373774856,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formSysDict:fragmentSysDict:update","permCodeList":["globalDict.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715666,1873979071373774856,'删除',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formSysDict:fragmentSysDict:delete","permCodeList":["globalDict.update"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715667,1873979071373774856,'同步缓存',3,NULL,NULL,NULL,NULL,NULL,5,NULL,'{"menuCode":"formSysDict:fragmentSysDict:reloadCache","permCodeList":["globalDict.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774857,1873979071365386241,'操作日志',1,'formSysOperationLog',NULL,NULL,NULL,NULL,140,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715669,1873979071373774857,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysOperationLog:fragmentSysOperationLog","permCodeList":["sysOperationLog.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979071373774858,1873979071365386241,'在线用户',1,'formSysLoginUser',NULL,NULL,NULL,NULL,145,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715671,1873979071373774858,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formSysLoginUser:fragmentLoginUser","permCodeList":["loginUser.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1873979271412715672,1873979071373774858,'强制下线',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formSysLoginUser:fragmentLoginUser:delete","permCodeList":["loginUser.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874031370079047680,NULL,'客户管理',0,NULL,NULL,NULL,NULL,NULL,9,NULL,'',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874031493945233408,1874031370079047680,'客户台账',1,'formCustomerInfo',NULL,NULL,NULL,NULL,1,NULL,'{}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525191,1874031493945233408,'显示',3,NULL,NULL,NULL,NULL,NULL,1,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo","permCodeList":["customerInfo.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525192,1874031493945233408,'新建',3,NULL,NULL,NULL,NULL,NULL,2,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo:addCustomerInfo","permCodeList":["customerInfo.add","customerInfo.update","customerInfo.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525193,1874031493945233408,'编辑',3,NULL,NULL,NULL,NULL,NULL,3,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo:editCustomerInfo","permCodeList":["customerInfo.add","customerInfo.update","customerInfo.view"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525194,1874031493945233408,'导出',3,NULL,NULL,NULL,NULL,NULL,4,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo:exportCustomerInfo","permCodeList":["customerInfo.export"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525195,1874031493945233408,'导入',3,NULL,NULL,NULL,NULL,NULL,5,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo:importCustomerInfo","permCodeList":["customerInfo.import"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
INSERT INTO `sys_menu` VALUES(1874137988699525196,1874031493945233408,'删除',3,NULL,NULL,NULL,NULL,NULL,6,NULL,'{"menuCode":"formCustomerInfo:formCustomerInfo:deleteCustomerInfo","permCodeList":["customerInfo.delete"]}',1873979071352803328,CURDATE(),1873979071352803328,CURDATE());
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
